﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using EyFramework.ORM;
using ShuJuGj.Entity;

namespace  ShuJuGj.Core.Dao
{
    /// <summary>
    ///  SJGJ_UPLOAD_DATA表的数据库操作 
    /// </summary>
    public class SjgjUploadDataDao : BaseDaoHis<SjgjUploadData>, ISjgjUploadDataDao
    {
        public List<string> GetUnloadData()
        {
            string sql =
                "SELECT WS01_00_018_01 FROM SJGJ_JKTJBGJL A WHERE NOT EXISTS(SELECT 1 FROM TJ_TJBG_PDF WHERE TJBH=A.WS01_00_018_01 AND SCBZ<>1)";
            return Db.Ado.SqlQuery<string>(sql).ToList();
        }
    }
}
